Icon

[02.CX] Viber Community Report JSON Parsing Workflow

Handeling JSON filesin a Google Drive Inside Paddy Community WorkflowThe JSON files are downloaded manually and stored in the Google Drive of the Digital Marketing team, and we (Data Analytics team) have access to them. In the future, we plan to implement an automated data extraction and ingestion process to transfer the data into the Snowflake Cloud Data Warehouse. 1) Context: We have launched a digital farming practices community in Myanmar byutilizing the widespread coverage of Viber users. Through these communities, weeducate farmers on the best practices to manage their farms, land, crops, pests &diseases, and yield. Viber serves as our platform to achieve these goals andconnect with farmers. The platform allows us to export JSON files, which contain daily-level-aggregateddata that highlights the status of the community. The digital marketing team isresponsible for launching new farming practices, educating, engaging, andmaintaining these communities. They regularly download these JSON files andreached out our team (Data Analytics team) for leveraging the power of data andanalytics to gain insights into community performance. datelikedautautwaumauExtractcolumnsmessages into separate columnsmembers intoseparate columnsMultiple fileshandlingPaddy CommunityAuthenticatedAccess to Google DriveCleaned Data for PBIDashboard Groundnut CommunitySesame Community Horticulture CommunityGrams Community String Manipulation String Manipulation String to Date&Time String Manipulation String Manipulation String Manipulation String Manipulation JSON Path Split CollectionColumn Column Filter Split CollectionColumn Column Rename JSON Reader ConstantValue Column GoogleAuthentication Google DriveConnector Column Filter Column Rename Concatenate Excel Writer Data Transformation Data Transformation Data Transformation Data Transformation Handeling JSON filesin a Google Drive Inside Paddy Community WorkflowThe JSON files are downloaded manually and stored in the Google Drive of the Digital Marketing team, and we (Data Analytics team) have access to them. In the future, we plan to implement an automated data extraction and ingestion process to transfer the data into the Snowflake Cloud Data Warehouse. 1) Context: We have launched a digital farming practices community in Myanmar byutilizing the widespread coverage of Viber users. Through these communities, weeducate farmers on the best practices to manage their farms, land, crops, pests &diseases, and yield. Viber serves as our platform to achieve these goals andconnect with farmers. The platform allows us to export JSON files, which contain daily-level-aggregateddata that highlights the status of the community. The digital marketing team isresponsible for launching new farming practices, educating, engaging, andmaintaining these communities. They regularly download these JSON files andreached out our team (Data Analytics team) for leveraging the power of data andanalytics to gain insights into community performance. datelikedautautwaumauExtractcolumnsmessages into separate columnsmembers intoseparate columnsMultiple fileshandlingPaddy CommunityAuthenticatedAccess to Google DriveCleaned Data for PBIDashboard Groundnut CommunitySesame Community Horticulture CommunityGrams Community String Manipulation String Manipulation String to Date&Time String Manipulation String Manipulation String Manipulation String Manipulation JSON Path Split CollectionColumn Column Filter Split CollectionColumn Column Rename JSON Reader ConstantValue Column GoogleAuthentication Google DriveConnector Column Filter Column Rename Concatenate Excel Writer Data Transformation Data Transformation Data Transformation Data Transformation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Data Analytics Team
Created at: 2023-04-16
On NodePit since: 2023-04-16
Last update: 2024-11-17
Created with KNIME version: v4.5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!